ItemInventoryHistory

Entity Definition

Logical Name : ItemInventoryHistory
Physical Name : LE_HST_INV_ITM

A unit record of a particular StockItem, held in a particular InventoryLocation, in a particular InventoryState and controlled or managed by a particular RevenueCenter during a particular historical ReportingPeriod.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ReportingPeriodID (FK)(PK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer ReportingPeriod(CA_PRD_RP)
ItemInventoryStateID (FK)(PK) A unique retailer assigned identifier for ItemInventoryStates. ID_ST_INV Identity integer ItemInventory(LE_INV_ITM)
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) ItemInventory(LE_INV_ITM)
LocationID (FK)(PK) A unique system assigned identifier for the Location. ID_LCN Identity integer ItemInventory(LE_INV_ITM)
RevenueCostCenterID (FK)(PK) A unique retailer assigned identifier for an accounting budget, that owns merchandise and is used to track the financial performance of the retail enterprise. ID_CTR_RVN_CST Identity integer ItemInventory(LE_INV_ITM)
BeginningUnitCount The number of units of the nominated Item present in the nominated InventoryLocation at the beginning of the nominated ReportingPeriod. QU_BGN Quantity DECIMAL(9,3)
GrossSalesUnitCount The number of units of the nominated Item sold from the nominated InventoryLocation since the beginning of the nominated ReportingPeriod, excluding any returns. QU_SLS Quantity DECIMAL(9,3)
ReturnUnitCount The number of units of the nominated Item returned to the nominated InventoryLocation since the beginning of the nominated ReportingPeriod. QU_RTN Quantity DECIMAL(9,3)
ReceivedUnitCount The number of units of the nominated Item received to the nominated InventoryLocation since the beginning of the nominated ReportingPeriod, excluding any returns. QU_RCV Quantity DECIMAL(9,3)
ReturnToVendorUnitCount The number of units of the nominated Item returned to Vendor from the nominated InventoryLocation since the beginning of the nominated ReportingPeriod. QU_RTV Quantity DECIMAL(9,3)
TransferInUnitCount The number of units of the nominated Item transferred into the nominated InventoryLocation since the beginning of the nominated ReportingPeriod. Note: Transfers include any Item's for which InventoryState was changed, but InventoryLocation did not change. QU_TSF_IN Quantity DECIMAL(9,3)
TransferOutUnitCount The number of units of the nominated Item transferred from the nominated InventoryLocation since the beginning of the nominated ReportingPeriod. Note: Transfers include any Item's for which InventoryState was changed, but InventoryLocation did not change. QU_TSF_OT Quantity DECIMAL(9,3)
AdjustmentUnitCount The number of units of the nominated Item for which InventoryAdjustments were made in the nominated InventoryLocation since the beginning of the nominated ReportingPeriod. QU_ADJT Quantity DECIMAL(9,3)
EndingUnitCount The number of units of the nominated Item present in the nominated InventoryLocation at the end of the nominated ReportingPeriod. QU_END Quantity DECIMAL(9,3)

Relationships

Parent Entity Verb Phrase Child Entity
ReportingPeriod delineates ItemInventoryHistory
ItemInventory is tracked by ItemInventoryHistory

Logical Views containing ItemInventoryHistory

Logical View
Logical 02000 - Item Inventory and Stock Ledger View
Logical 03000 - Reporting - Macro View
Logical 03000 - Reporting - Macro View
Logical 03300 - Reporting - Stock Ledger View